<?
//搜索需要提示的信息。



$unpay_member=select_lines_all_items($table_Prefix."member","nid desc","status = '欠费' and (sid is null or sid = '0')","");


$applymodify_member=select_lines_all_items($table_Prefix."member","nid desc","sid > 0 and applystatus = '申请修改'","");

$repair_equipment=select_lines_all_items($table_Prefix."equipment","nid desc","status = '维修'","");

$material_lack=select_lines_all_items($table_Prefix."material","nid desc","stockstatus != '充足'","");




$alert_date=date("Y-m-d",strtotime("+30 day"));


//季审即将过期
$equipment_jishen=select_lines_all_items($table_Prefix."equipment","jishen asc","nianshen < '".$alert_date."'","");



//年审即将过期
$equipment_nianshen=select_lines_all_items($table_Prefix."equipment","nianshen asc","jishen < '".$alert_date."'","");


//保险即将过期
$equipment_qiangbao=select_lines_all_items($table_Prefix."equipment","qiangbao asc","qiangbao < '".$alert_date."'","");

//保险即将过期
$equipment_quanbao=select_lines_all_items($table_Prefix."equipment","quanbao asc","quanbao < '".$alert_date."'","");



//学员即将过期

$student_expire_date=date("Y-m-d",strtotime("-30 months"));

$student_expire_sql="SELECT athlon_member.name,athlon_member.nid,athlon_member.graduate,athlon_exam.name,athlon_exam.applydate FROM athlon_member,athlon_exam WHERE athlon_member.nid = athlon_exam.masterid and athlon_exam.name = '科目一理论考试' and athlon_exam.status = '通过' and athlon_member.graduate ='未结业' and athlon_exam.applydate < '".$student_expire_date."'";



$result = mysql_query($student_expire_sql);

while($row = mysql_fetch_array($result))
{
    $student_expire_list[]             =$row;
}




mysql_close($con);




//<dd><a href="">运输证即将过期</a></dd>
//<dd><a href="">教练车年审过期</a></dd>





//<dd><a href="">学员身份证即将过期</a></dd>
//<dd><a href="">教练身份证即将过期</a></dd>
//<dd><a href="">教练驾驶证即将过期</a></dd>


//<dd><a href="">教练车二级维护过期</a></dd>
//<dd><a href="">教练车技术等级评定过期</a></dd>
//<dd><a href="">教练车交强险过期</a></dd>
//<dd><a href="">教练车商业险过期</a></dd>
//<dd><a href="">车船税过期</a></dd>
?>


